Multiple If Statements in One

[MROMAR]

If trying to do an If statment that combines two things.

In cell F25 I have an actual result, in cell D25 I have a goal, if the result is greater than the goal which is 1, the result is zero, but if it equals 1(the value of cell D25) then the desired output is cell B25. I also have a maximum goal of zero in E25 and if cell F25 = E25 the desired output should be B25*B20.

I know it has to be a combination of If/And statments, just having trouble coming up with the formula.

Any suggestions?

[twiggywales]

easier to up a book to let us see but here we go something like

=IF(F25=E25,B25*B20,IF(F25>D25,0,IF(F25=D25,B25)))

bit confusing what your tring to do.

[MROMAR]

Thank alot, works perfect!

[twiggywales]

great, try not to use to many nested ifs it can get confusing to anyone viewing your sheet.

(also rember to mark your thread solved)