IF FORMULA

Closed
hammad94
Posts
1
Registration date
Friday June 13, 2014
Status
Member
Last seen
June 13, 2014
- Jun 13, 2014 at 10:38 AM
 Blocked Profile - Jun 13, 2014 at 02:09 PM
What is the mistake in this formula ??
=IF((D10>(B10/2))&((F10)<(B10/2));"[514*D2*(SQRT((f10*d10)/(d5*d4)))]";"[257*d2*b10*(1/(d5*d4))]")
I GET ERROR #value!

1 reply

Blocked Profile
Jun 13, 2014 at 02:09 PM
I beleive the brackets tell the spreadsheet it is a "name". Replace the brackets with another set of (), instead of []. Give that a try

0