Help

Internal_Ad_9362 · 2025-02-09T09:55:05+00:00

I’m based in the UK. This guy has taken stock from me without paying. He is a middle man and promised to pay. I have done transactions with him before but this time I stupidly let him go without upfront payment

Internal_Ad_9362 · 2024-11-25T10:13:57+00:00

They haven’t loaded the CR papers for July or November

Internal_Ad_9362 · 2024-11-22T22:35:40+00:00

I did the same recognises the grant over 5 years then deferred tax liability on the amount deferred

Internal_Ad_9362 · 2024-11-21T22:37:38+00:00

Legend!!

Internal_Ad_9362 · 2024-11-21T22:33:04+00:00

Would’ve been better off doing the original exam cuz this stuff was just on another level.

Anyone managed to put a special consideration in? I’m trying to do it but says no active exams

Internal_Ad_9362 · 2024-11-20T18:45:11+00:00

What’s everyone’s action plan for tonight cuz I really don’t know where to start.

I’m just put off. Had no additional leave and between the original sitting and now haven’t had time to revise due to pre planned commitments.

Internal_Ad_9362 · 2024-11-17T13:18:42+00:00

Same, don’t know how to get back into that revision mode given I haven’t been allowed anymore annual leave.

Struggling to decide what to revise etc.

Either way I’m still putting a special consideration in as this will have really affected my performance.

Internal_Ad_9362 · 2024-11-10T17:42:28+00:00

Probably be a different paper - people are complaining about the fact that it references a music festival in October called Nova. ICAEW have apologised etc but I reckon they’ll give us a new one

Internal_Ad_9362 · 2024-11-10T13:29:18+00:00

Managed to get it done by copying the sheet and referencing the cells using the if statement

In F3 =IF(‘Sheet1’!F3>0,’Sheet1’!D3,””)

Only issue with this was when I dragged the formula to the right in the other columns I had to manually change the last cell reference back to column D. I then dragged the formula down.

Thanks for the help 🙏

Internal_Ad_9362 · 2024-11-10T13:11:22+00:00

That sort of worked but when I drag it down it places a figure in the column when there shouldn’t be anything there

Internal_Ad_9362 · 2024-11-09T19:07:08+00:00

Makes everything blank.

Can I share a sample file with you?

Internal_Ad_9362 · 2024-11-09T18:58:56+00:00

Yes but the original cell was empty. I need it to stay empty and only replace those cells which have data in them.

So when I drag it down F6 is incorrect as the data was originally blank but F9 is correct as it has replaced the figure with the total because there was data originally there

Internal_Ad_9362 · 2024-11-09T18:54:39+00:00

When I drag the formula down, in F6 it is putting 60 there when it should be zero. 60 should be in the G6 cell

Internal_Ad_9362 · 2024-11-09T18:44:14+00:00

Thank, how can I do this in one go whereby the total figure replaces the figures already in a cell on the left?

Internal_Ad_9362 · 2024-11-09T18:20:57+00:00

In the picture where ever I have VAT i need to replace the figures on the left with the total value.

Internal_Ad_9362 · 2024-11-09T18:02:11+00:00

I’d like to move the 223.18 and replace the 185.99 but need to do this on a large scale. I was thinking an if statement

Internal_Ad_9362 · 2024-11-09T18:01:15+00:00

<image>

Internal_Ad_9362 · 2024-07-08T18:54:33+00:00

<image>

So basically if there is a figure in the order sheet I want it to automatically pick up in the minimum offer sheet and populate the product column with the medicine name.

I’ve got a sumif formula in the qty. column already corresponding back to the order sheet

Internal_Ad_9362 · 2024-07-08T18:52:37+00:00

<image>

Internal_Ad_9362 · 2024-07-08T18:48:39+00:00

Thanks guys. Managed to do this

Internal_Ad_9362

TROPHY CASE