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!

IF FORMULA
Logitech formula vibration feedback wheel driver - Download - Drivers
Credit summation formula - Guide
Number to words in excel formula - Guide
Formula spreadsheet definition - Guide
Date formula in excel dd/mm/yyyy - Guide

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

Similar discussions

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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

Similar discussions

Subscribe To Our Newsletter!