Division

**samjs** · 02-22-2010, 01:40 AM

Hello, not sure if I am in the correct area, I don't post in forums often.

I am creating a spreedsheet where I need to divided the value of one cell by another. E.g
=A1/A2

However the numerator could either be in one of two fields i.e A2 or A3.

I need to write a fomular where if A2 is blank it will use the value of A3.

Many thanks

**pike** · 02-22-2010, 01:49 AM

Maybe...

=IF(A2<>"",A1/A2,A1/A3)

**teylyn** · 02-22-2010, 01:49 AM

Hi samjs,

welcome to the forum.

There are several ways you can do this, e.g.

=A1/max(A2,A3)
=A1/if(isblank(A2),A3,A2)
=A1/sum(A2:A3)

probably more. Take your pick