Previous Topic Next Topic

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 response

Answer 1 / 1
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response