Formula Assistance Please

[johnb1979]

Hi all,

I'm pretty sure this is a simple solution for some but I'm struggling and would really appreciate some help please!

If cell A1 is less than the value of B1 then C1 should show 0. However, if A1 is equal to or greater than B1 then C1 should be equal E1. Then I need the following - If A1 is greater than B1 then B1 minus F1, then multiplied by G1.

I hope this all makes sense. Essentially looking for 2 results shown in different cells (formulas for and results shown in C1 & D1).

Thanks for your help!!!

 

[Peter_SSs]

If A1 is greater than B1 then B1 minus F1,

You did not say what to return for the second formula if A1<=B1.
Anyway, see if this heads you in the right direction.

23 10 06.xlsm
	A	B	C	D	E	F
1	3	8	0	??	222	1
2	8	3	222	2	222	1
johnb1979

Cell Formulas
Range	Formula
C1:C2	C1	=IF(A1<B1,0,E1)
D1:D2	D1	=IF(A1>B1,B1-F1,"??")

 

[johnb1979]

You did not say what to return for the second formula if A1<=B1.
Anyway, see if this heads you in the right direction.

23 10 06.xlsm
	A	B	C	D	E	F
1	3	8	0	??	222	1
2	8	3	222	2	222	1
johnb1979

Cell Formulas
Range	Formula
C1:C2	C1	=IF(A1<B1,0,E1)
D1:D2	D1	=IF(A1>B1,B1-F1,"??")

That's great, thank you Peter and thanks for spotting my error!

The first formula works great thank you...the 2nd is almost there. I need to find a % of the result of B1-F1 in the 2nd formula. The % may change so rather than including a fixed % in the actual formula, I'd like to put the % in another cell (G1 in this example), so that if I change the %, the formula will automatically work...hope that makes sense?

Thanks again, really appreciate you time!

 

[Peter_SSs]

the 2nd is almost there. I need to find a % of the result of B1-F1 in the 2nd formula.

You still did not say what to return if A1<= B1

 

[johnb1979]

You still did not say what to return if A1<= B1

Sorry, I don't seem to be doing a very good job of explaining myself - but I've used your original suggestion and have managed to make it work now so thank you again , that's been a great help!!

 

[Peter_SSs]

Glad you got it sorted. Thanks for letting us know.